FaFundSource

Logical Entity Name | FaFundSource
Default Table Name | FaFundSource
Physical Only | NO
Owner | dbo
Definition |
Note |

FaFundSource Columns

ColumnName | Domain | Datatype | NULL | Definition
faFundSourceID |  | int | NO |
Code |  | char(8) | NO |
Descrip |  | varchar(40) | NO |
SyCampusGrpID |  | int | NO |
Title4 |  | bit | NO |
Type |  | char(8) | NO |
GraceDays |  | numeric(4, 0) | YES |
SAApplySchedID |  | int | YES |
ThirdPartyCode |  | varchar(20) | YES |
CancelDropDays |  | numeric(3, 0) | YES |
Comment |  | text | YES |
Active |  | bit | NO |
EFT |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
FaBankID |  | int | YES |
FaGuarantorID |  | int | YES |
FaServicerID |  | int | YES |
OverPaymentFlag |  | char(1) | YES |
ReceiptComment |  | text | YES |
RequireScheduledDisb |  | bit | NO |
IsSeog |  | bit | NO |
IsStudentBorrower |  | bit | NO |
SEOGMatchPct |  | numeric(5, 2) | YES |
AllowManualPost |  | bit | NO |
FaGLFundID |  | int | YES |
NextPaymentDue |  | int | YES |
RefundPayableTo |  | varchar(150) | YES |
30DisbDropFlag |  | bit | YES |
IntChargeMethod |  | char(1) | YES |
InterestRecalc |  | bit | NO |
EditRefund |  | bit | NO |
EditStipend |  | bit | NO |
RoundDisbs |  | bit | NO |
COA |  | bit | NO |
IncludeRemainNeed |  | bit | NO |
OthNonFedResource |  | bit | YES |
IncludeIn1098T |  | bit | NO |
AssociateCoursesToPayments |  | bit | NO |
UseForOutsideCollections |  | bit | NO |
CollectionsGracePeriod |  | tinyint | YES |
AllowPromissoryNote |  | bit | NO |
ApplyInterestFirst |  | bit | NO |
Institutional |  | bit | NO |
CustomizeDescrip |  | bit | NO |
RefundDescrip |  | varchar(100) | YES |
StipendDescrip |  | varchar(100) | YES |
ReqDisbSched |  | bit | NO |
ReserveRate2009For9010Report |  | decimal(7, 3) | YES |
ReserveRate2010For9010Report |  | decimal(7, 3) | YES |
ReserveRate2011For9010Report |  | decimal(7, 3) | YES |
ReserveRate2012For9010Report |  | decimal(7, 3) | YES |
InstitutionalScholarshipOrGrant |  | bit | NO |
requiredtotakeattendance |  | bit | NO |
ExcludeFromEFA |  | bit | NO |
SyStateID |  | int | YES |
IsNeedBased |  | char(1) | NO |
IsMilitaryTA |  | bit | NO |
IsMilitaryVA |  | bit | NO |
IsNonTaxable |  | bit | NO |
IsFoundation |  | bit | NO |
IsMeritBased |  | bit | NO |
Address |  | varchar(255) | YES |
City |  | char(35) | YES |
State |  | char(2) | YES |
Zip |  | char(10) | YES |
Phone |  | varchar(16) | YES |
AutoApproveOnCreate |  | bit | NO |
PortalStudentApprove |  | bit | NO |
IsRestrictMinPaymt |  | bit | NO |
IsTila |  | bit | NO |
UseIndLoanCalcFor9010Report |  | bit | YES |
ServiceRequired |  | bit | NO |
TitleVIIEligible |  | bit | NO |
NoelLevitzSource |  | char(1) | NO |
NoelLevitzBasis |  | char(1) | NO |
NoelLevitzFunding |  | char(1) | NO |
NoelLevitzAwardType |  | char(1) | NO |
SummerTermAwarding |  | bit | NO |
IsAutoCreatePayment |  | bit | NO |
AutoPaymentDueBy |  | tinyint | NO |
AutoPaymentDays |  | int | NO |
StipendPostingForNonDisbursedFunds |  | bit | NO |
IsOtherOutsideGrant |  | bit | NO |
AllowCrossOverPELL |  | bit | NO |
ShowInStudentPortal |  | bit | NO |
ExcludeFrom9010Report |  | bit | NO |
NonT4EducationFund |  | bit | NO |
CommingledFund |  | bit | NO |
NonFederalPercent |  | numeric(5, 2) | YES |

FaFundSource Primary and Unique Keys

Key Name | Key Type | Keys
FaFundSource_faFundSourceID_U_C_IDX | PrimaryKey | faFundSourceID

FaFundSource Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
FaGLFund | Non-Identifying | Zero or One to Zero or More | FK_FaFundSource_FaGLFundID_FaGLFund_FaGLFundID |  |  | FaGLFundID | NO | YES
FaFundSourceType | Non-Identifying | One To Zero or More | FK_FaFundSource_Type_FaFundSourceType_Code |  |  | Type | NO | YES
syState | Non-Identifying | Zero or One to Zero or More | FK_FaFundSourceSyStateID_SyStateSyStateID |  |  | SyStateID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
amAgency | Non-Identifying | One To Zero or More | FK_AmAgency.FaFundSourceID_FaFundSource.FaFundSourceID |  |  |  | NO | YES
CmActionsFundSourceDetail | Non-Identifying | One To Zero or More | FK_CmActionsFundSourceDetail_FaFundSourceId_FaFundSource_FaFundSourceId |  |  |  | NO | NO
FaAwardYearFundSourceDisable | Non-Identifying | One To Zero or More | FK_FaAwardYearFundSourceDisable_FaFundSourceID_FaFundSource_FaFundSourceID |  |  |  | NO | YES
FaCashPlanConfiguration | Non-Identifying | One To Zero or More | FK_FaCashPlanConfigurationFaFundSourceId_FaFundSourceFaFundSourceId |  |  |  | NO | YES
FaDisbCriteriaCampusFundSource | Identifying | One To Zero or More | FK_FaDisbCriteriaCampusFundSource_FaFundSourceID_FaFundSource_faFundSourceID |  |  |  | NO | YES
FaEstimateAward | Non-Identifying | One To Zero or More | FK_FaEstimateAward_FaFundSourceID_FaFundSource_faFundSourceID |  |  |  | NO | YES
FaFundSourceAutoAwardRules | Non-Identifying | One To Zero or More | FK_FaFundSourceAutoAwardRules_FaFundSourceId_FaFundSource_FaFundSourceId |  |  |  | NO | YES
FaFundSourceBanks | Identifying | One To Zero or More | FK_FaFundSourceBanks_FaFundSourceID_FaFundSource_FaFundSourceID |  |  |  | NO | YES
FaFundSourcePriority | Non-Identifying | One To Zero or More | FK_FaFundSourcePriority_FaFundSource |  |  |  | NO | YES
FaMultiDisbSchedRuleCriteria | Non-Identifying | One To Zero or More | FK_FaMultiDisbSchedRuleCriteria_FaFundSourceID_FaFundSource |  |  |  | NO | YES
FaProgramVersion_PaymentPeriodNonTitleIV | Non-Identifying | One To Zero or More | FK_FaProgramVersion_PaymentPeriodNonTitleIV_FaFundSourceId_FaFundSource_FaFundSourceId |  |  |  | NO | YES
FaStudentAid | Non-Identifying | One To Zero or More | FK_FaStudentAid_FaFundSourceID_FaFundSource_faFundSourceID |  |  |  | NO | YES
FaStudentAidCashPlanHistory | Non-Identifying | One To Zero or More | FK_FaStudentAidCashPlanHistory_FaFundSource_FaFundSourceId |  |  |  | NO | YES
FaStudentFundSource | Non-Identifying | One To Zero or More | FK_FaStudentFundSourceFaFundSourceId_FaFundSourceFaFundSourceId |  |  |  | NO | YES
SaBankAccountFS | Non-Identifying | One To Zero or More | FK_SaBankAccountFS_FaFundSourceID_FaFundSource_FaFundSourceID |  |  |  | NO | YES
SaCreditSourceApplyOrder | Non-Identifying | One To Zero or More | Fk_SaCreditSourceApplyOrder_FaFundSourceId |  |  |  | NO | NO
SaFundSourceOrder | Non-Identifying | One To Zero or More | FK_SaFundSourceOrder_FaFundsourceID_FaFundsource_FaFundsourceID |  |  |  | NO | YES
SaPaymentApply | Non-Identifying | One To Zero or More | FK_SaPaymentApply_FaFundSourceId_FaFundSource_FaFundSourceId |  |  |  | NO | YES
SaPaymentApplyOrder | Non-Identifying | One To Zero or More | FK_SaPaymentApplyOrder_FaFundSourceId_FaFundSource_FaFundSourceId |  |  |  | NO | YES
SYFSStaffGroup | Non-Identifying | One To Zero or More | FK_SYFSStaffGroup_FAFundSourceID_FaFundSource_faFundSourceID |  |  |  | NO | YES
SyStateReportFundSourceMapping | Non-Identifying | One To Zero or More | FK_SyStateReportFundSourceMapping_FaFundSourceID_FaFundSource_FaFundSourceID |  |  |  | NO | YES

FaFundSource Check Constraints

Check Constraint Name | CheckConstraint

FaFundSource Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

FaFundSource Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FundSource | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaFundSource | NO |  |  |

FaFundSource Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | RefundCalculation
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaFundSource Data Movement Rules

Name | Type | Rule Text/Value